CREATE PROCEDURE P_SHUIDIAN_CALC  
    @vmonth VARCHAR(255)  
AS  
BEGIN  
    SELECT * FROM IMP_SHUIDIAN WHERE vmonth = @vmonth  
END  
GO

CREATE PROCEDURE P_SHUIDIAN_CALC  
    @vmonth VARCHAR(255)  
AS  
BEGIN  
    insert into IMP_SHUIDIAN (vmonth) VALUES (@vmonth)
END
GO

EXEC P_SHUIDIAN_CALC @vmonth = '2024-07'

insert into IMP_SHUIDIAN (vmonth) VALUES ('2024-30')

DROP PROCEDURE IF EXISTS dbo.P_SHUIDIAN_CALC



CREATE PROCEDURE P_SY_STAFF
BEGIN  
		DECLARE i int DEFAULT 0;
		DECLARE n int DEFAULT 0;
    SELECT * FROM IMP_SHUIDIAN WHERE vmonth = @vmonth  
END  
GO

CREATE PROCEDURE P_SHUIDIAN_CALC  
    @vmonth VARCHAR(255)  
AS  
BEGIN  
    insert into IMP_SHUIDIAN (vmonth) VALUES (@vmonth)
END
GO

EXEC P_SHUIDIAN_CALC @vmonth = '2024-07'

insert into IMP_SHUIDIAN (vmonth) VALUES ('2024-30')

DROP PROCEDURE IF EXISTS dbo.P_SHUIDIAN_CALC

